Bahwan 3rd Round Interview

1. Diff between varchar and varchar2
2. View and Mview
3. Table a -- 
      Id, Name
       1, a
     Table b --
     Id, name
     No values
    
  Select * from a,b;

 4.Table a -- 
      Id, Name
       1, a
     Table b --
     Null,nu

     Select * from a,b;
     Select * from a,b where a.id = b.id;

5. Tell About Yourself
6.where is your company located

7.What is long data type

8.What happens to the index when itss column alone is dropped

9. O/p of
   
   Begin
   End;
   /


   Begin
     Update t1 set col1 = a;
   End;
   /


   Begin
     Alter table t1 add b   
                              number;
   End;
   /